Comparing Dates to Current Time - Mailing list pgsql-sql

From Jenny DiBartolomeo
Subject Comparing Dates to Current Time
Date
Msg-id v0401170fb31ee296d1cc@[206.100.119.176]
Whole thread Raw
List pgsql-sql
OK... this is probably a trivial one.  In an Oracle query, I might do the
following select statement:

   SELECT title

     FROM articles

    WHERE expires > SYSDATE

How would I do the same thing in Postgres if the column "expires" is of the
data type "DATE"?  I've tried everything and read the man pages and can't
seem to get it working!  Any help would be VERY APPRECIATED!!!

Thanks sooooo much for any help you can give me!!!!  Please respond via
email to jdibartolomeo@agency.com.

-Jenny

------------------------------
Jennifer DiBartolomeo
jdibartolomeo@agency.com
------------------------------

pgsql-sql by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: [SQL] DEFAULT TEXT 'now'
Next
From: Jenny DiBartolomeo
Date:
Subject: Comparing Dates to Current Time